﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Agresso.Interface.Layer.SQL
{
    public class ConfigurationSettingSQL
    {
        public static string Insert()
        {
            return @"INSERT INTO i_conf_settings
           ([setting_name]
           ,[val_1]
           ,[val_2]
           ,[val_3]
           ,[val_4]
           ,[val_5]
           ,[val_6]
           ,[val_7]
           ,[val_8]
           ,[val_9]
           ,[val_10]
            ,[val_11]
            ,[val_12]
            ,[val_13]
            ,[val_14])
     VALUES
           (@setting_name
           ,@val_1
           ,@val_2
           ,@val_3
           ,@val_4
           ,@val_5
           ,@val_6
           ,@val_7
           ,@val_8
           ,@val_9
           ,@val_10
            ,@val_11
             ,@val_12
             ,@val_13
             ,@val_14
            )";
        }
        public static string Update()
        {
            return @"
            UPDATE i_conf_settings
   SET [setting_name] = @setting_name
      ,[val_1] = @val_1
      ,[val_2] = @val_2
      ,[val_3] = @val_3
      ,[val_4] = @val_4
      ,[val_5] = @val_5
      ,[val_6] = @val_6
      ,[val_7] = @val_7
      ,[val_8] = @val_8
      ,[val_9] = @val_9
      ,[val_10] = @val_10
       ,[val_11] = @val_11
,[val_12] = @val_12
,[val_13] = @val_13
,[val_14] = @val_14
 WHERE setting_name = @setting_name
            ";
        }
        public static string GetBySettingName()
        {
            return @"select * from i_conf_settings where  setting_name = @setting_name";
        }

    }
}
